package com.ffcs.crmd.tsp.server.jdbc;

public interface ColConstants {
    
    // Table names
    final String TABLE_CLUSTER                                  = "TSP_CLUSTER";
    
    final String TABLE_CLUSTER_INSTANCE                         = "TSP_CLUSTER_INSTANCE";
    
    final String TABLE_JOB_GROUP                                = "TSP_JOB_GROUP";
    
    final String TABLE_JOB                                      = "TSP_JOB";
    
    final String TABLE_JOB_DETAIL                               = "TSP_JOB_DETAIL";
    
    final String TABLE_JOB_DETAIL_PARAM                         = "TSP_JOB_DETAIL_PARAM";
    
    final String TABLE_JOB_IDENTITY_INFO                        = "TSP_JOB_IDENTITY_INFO";
    
    final String TABLE_TASK_IDENTITY                            = "TSP_TASK_IDENTITY";
    
    final String TABLE_SLICE                                    = "TSP_SLICE";
    
    final String TABLE_SLICE_GROUP                              = "TSP_SLICE_GROUP";
    
    // Table common columns names
    
    final String COL_ID                                         = "ID";
    
    final String COL_NAME                                       = "NAME";
    
    final String COL_CLUSTER_NAME                               = "CLUSTER_NAME";
    
    final String COL_DESCRIPTION                                = "DESCRIPTION";
    
    // Table TSP_JOB_DETAIL columns names
    
    final String COL_JOB_DETAIL_RUNNING                         = "RUNNING";
    
    final String COL_JOB_DETAIL_JOB_ID                          = "JOB_ID";
    
    final String COL_JOB_DETAIL_START_TIME                      = "START_TIME";
    
    final String COL_JOB_DETAIL_END_TIME                        = "END_TIME";
    
    final String COL_JOB_DETAIL_JOB_NAME                        = "JOB_NAME";
    
    // Table TSP_JOB_DETAIL_PARAM columns names
    
    final String COL_JOB_DETAIL_PARAM_MEKY                      = "MKEY";
    
    final String COL_JOB_DETAIL_PARAM_MVALUE                    = "MVALUE";
    
    final String COL_JOB_DETAIL_PARAM_JOB_DETAIL_ID             = "JOB_DETAIL_ID";
    
    // Table TSP_JOB_IDENTITY_IFNO columns names
    final String COL_JOB_IDENTITY_INFO_IDENTITY                 = "IDENTITY";
    
    final String COL_JOB_IDENTITY_INFO_TASK_IDENTITY_ID         = "TASK_IDENTITY_ID";
    
    final String COL_JOB_IDENTITY_INFO_JOB_ID                   = "JOB_ID";
    
    final String COL_JOB_IDENTITY_INFO_DESCRIPTION                   = "DESCRIPTION";
    
    // Table TSP_JOB columns names
    final String COL_JOB_JOB_CLASS                              = "JOB_CLASS";
    
    final String COL_JOB_CRON_EXPRESSION                        = "CRON_EXPRESSION";
    
    final String COL_JOB_REPEAT_COUNT                           = "REPEAT_COUNT";
    
    final String COL_JOB_REPEAT_INTERVAL                        = "REPEAT_INTERVAL";
    
    final String COL_JOB_EXECUTE_TIMEOUT                        = "EXECUTE_TIMEOUT";
    
    final String COL_JOB_JOB_TYPE                               = "JOB_TYPE";
    
    final String COL_JOB_REPEAT_TYPE                            = "REPEAT_TYPE";
    
    final String COL_JOB_MISFIRE_INSTRUCTION                    = "MISFIRE_INSTRUCTION";
    
    final String COL_JOB_PRIORITY                               = "PRIORITY";
    
    final String COL_JOB_SHOULD_RECOVER                         = "SHOULD_RECOVER";
    
    final String COL_JOB_JOB_GROUP_ID                           = "JOB_GROUP_ID";
    
    final String COL_JOB_RESET_DEATH_DELAY_TIME                 = "RESET_DEATH_DELAY_TIME";
    
    final String COL_JOB_TIMEOUT_POLICY                         = "TIMEOUT_POLICY";
    
    final String COL_JOB_JOB_GROUP_NAME                         = "JOB_GROUP_NAME";
    
    final String COL_JOB_BUFFER_SIZE_LIMIT                      = "BUFFER_SIZE_LIMIT";
    
    // Table TSP_SLICE_GROUP columns names
    
    final String COL_SLICE_GROUP_JOB_NAME                       = "JOB_NAME";
    
    final String COL_SLICE_GROUP_JOB_ID                         = "JOB_ID";
    
    // Table TSP_SLICE columns names
    
    final String COL_SLICE_SKEY                                 = "SKEY";
    
    final String COL_SLICE_SLICE_GROUP_ID                       = "SLICE_GROUP_ID";
    
    // Table TSP_TASK_IDENTITY columns names
    
    final String COL_TASK_IDENTITY_JOB_GROUP_ID                 = "JOB_GROUP_ID";
    
    final String COL_TASK_IDENTITY_IDENTITY                     = "IDENTITY";
    
    final String COL_TASK_IDENTITY_THREAD_PRIORITY_WEIGHT       = "THREAD_PRIORITY_WEIGHT";
    
    final String COL_TASK_IDENTITY_BATCH_THREAD_PRIORITY_WEIGHT = "BATCH_THREAD_PRIORITY_WEIGHT";
    
    final String COL_TASK_IDENTITY_THREAD_NUM                   = "THREAD_NUM";
    
    final String COL_TASK_IDENTITY_BATCH_THREAD_NUM             = "BATCH_THREAD_NUM";
    
}
